Prepared statement issue in Pgpool-II
am 28.06.2010 23:32:03 von raghu ram
--0016364edb1c06a811048a1ddab3
Content-Type: text/plain; charset=ISO-8859-1
Hi,
We are using pgool-II version 2.3.2.2 (tomiteboshi)and postgres 8.3.9 and
facing the below error while running the select queries in the application
side::
ERROR: prepared statement
"mdb2_statement_pgsql_71417ca02c1aa9cec1dd2570c46e992e" does not exist
STATEMENT: DEALLOCATE PREPARE
mdb2_statement_pgsql_71417ca02c1aa9cec1dd2570c46e992e
WARNING: archive_mode enabled, yet archive_command is not set
In the pgpool.conf file set the "reset_query_list" ='ABORT; RESET ALL; SET
SESSION AUTHORIZATION DEFAULT'
We also tested on pgpool-II version 2.3.3, result will be same.
Please help us to resolve the issue.
Regards
Raghu
--0016364edb1c06a811048a1ddab3
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Hi,
<=
p style=3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Courier">
<=
p style=3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Courier">
<=
p style=3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Courier">
We are using pgool-II version 2.3.2.2 (tomiteboshi)and postgres 8.3.9 and f=
acing the below error while running the select queries in the application s=
ide::
ht: 16.0px">
=A0ERROR=
:=A0 prepared statement "mdb2_statement_pgsql_71417ca02c1aa9cec1dd2570=
c46e992e" does not exist
=A0STATE=
MENT:=A0 DEALLOCATE PREPARE mdb2_statement_pgsql_71417ca02c1aa9cec1dd2570c4=
6e992e
=A0WARNI=
NG:=A0 archive_mode enabled, yet archive_command is not set
ht: 16.0px">
In the p=
gpool.conf file set the "reset_query_list" =3D'ABORT; RE=
SET ALL; SET SESSION AUTHORIZATION DEFAULT'
ht: 16.0px">
px Courier; min-height: 16.0px">We also tested on=A0pgpool-II version 2.3.3=
, result will be same.
ht: 16.0px">
px Courier; min-height: 16.0px">Please help us to resolve the issue.
style=3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Courier">
=
Regards
r">Raghu
--0016364edb1c06a811048a1ddab3--
Re: Prepared statement issue in Pgpool-II
am 29.06.2010 09:48:34 von raghu ram
--001517511876e39215048a2676d3
Content-Type: text/plain; charset=ISO-8859-1
On Tue, Jun 29, 2010 at 3:25 PM, Vibhor Kumar
> wrote:
> On 28/06/10 10:32 PM, raghu ram wrote:
>
>>
>> ERROR: prepared statement
>> "mdb2_statement_pgsql_71417ca02c1aa9cec1dd2570c46e992e" does not exist
>>
>> STATEMENT: DEALLOCATE PREPARE
>> mdb2_statement_pgsql_71417ca02c1aa9cec1dd2570c46e992e
>>
>> WARNING: archive_mode enabled, yet archive_command is not set
>>
>>
>> In the pgpool.conf file set the "reset_query_list" ='ABORT; RESET ALL;
>> SET SESSION AUTHORIZATION DEFAULT'
>>
>>
> Change the parameter setting reset_query_list = 'ABORT; DISCARD ALL'
>
>
Thanks Vibhor...
If you set the reset_query_list = 'ABORT; DISCARD ALL'
(or) reset_query_list = 'ABORT; DISCARD TEMPORARY' also getting the same
error again for both version of the Pgpool-II.
Thanks&Regards
Raghu
--
> Thanks& Regards,
> Vibhor Kumar.
> Senior System Engineer.
>
> EnterpriseDB Corporation
> The Enterprise Postgres Company
>
> Office: 732-331-1300 Ext-2022
>
> Website: www.enterprisedb.com
> EnterpriseDB Blog: http://blogs.enterprisedb.com
> Follow us on Twitter: http://www.twitter.com/enterprisedb
>
>
--001517511876e39215048a2676d3
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
On Tue, Jun 29, 2010 at 3:25 PM, Vibhor =
Kumar
<
">vibhor.kumar@enterprisedb.com> wrote:
=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padd=
ing-left:1ex;">
On 28/06/10 10:32 PM, raghu ram wrote:
x #ccc solid;padding-left:1ex">
ERROR: =A0prepared statement "mdb2_statement_pgsql_71417ca02c1aa9cec1d=
d2570c46e992e" does not exist
=A0STATEMENT: =A0DEALLOCATE PREPARE mdb2_statement_pgsql_71417ca02c1aa9cec1=
dd2570c46e992e
=A0WARNING: =A0archive_mode enabled, yet archive_command is not set
In the pgpool.conf file set the =A0"reset_query_list" =3D'ABO=
RT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT'
Change the parameter setting reset_query_list =3D 'ABORT; DISCARD ALL&#=
39;
Thanks Vibhor...
=
If you set the =A0reset_query_list =3D 'ABORT; DISCARD ALL&#=
39; =A0(or)=A0reset_query_list =3D 'ABORT; DISCARD TEMPORARY' also =
getting the same error again for both version of the Pgpool-II.
Thanks&Regards
Raghu
=
rgin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
=3D"#888888">
--
Thanks& =A0Regards,
Vibhor Kumar.
Senior System Engineer.
--001517511876e39215048a2676d3--
Re: Prepared statement issue in Pgpool-II
am 29.06.2010 11:55:58 von Vibhor Kumar
On 28/06/10 10:32 PM, raghu ram wrote:
>
> ERROR: prepared statement
> "mdb2_statement_pgsql_71417ca02c1aa9cec1dd2570c46e992e" does not exist
>
> STATEMENT: DEALLOCATE PREPARE
> mdb2_statement_pgsql_71417ca02c1aa9cec1dd2570c46e992e
>
> WARNING: archive_mode enabled, yet archive_command is not set
>
>
> In the pgpool.conf file set the "reset_query_list" ='ABORT; RESET
> ALL; SET SESSION AUTHORIZATION DEFAULT'
>
Change the parameter setting reset_query_list = 'ABORT; DISCARD ALL'
--
Thanks& Regards,
Vibhor Kumar.
Senior System Engineer.
EnterpriseDB Corporation
The Enterprise Postgres Company
Office: 732-331-1300 Ext-2022
Website: www.enterprisedb.com
EnterpriseDB Blog: http://blogs.enterprisedb.com
Follow us on Twitter: http://www.twitter.com/enterprisedb
--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice